Introducing UMLet: excellent free UML tool

Just as the saying stands: "Reduce everything to its essence so that form harmonizes with function", graphical diagramming notations have considerably helped for better communication and understanding in Software Development.

A diagram can help us better express our ideas about Software Design without putting textual explanations. It's already confirmed that human brain better processes images than texts. That's why graphical representation through diagrams is quite effective to communicate and express our ideas either for a Software System or a Business Process.

By: Leo On 14:24

Continue Reading

Case Sample: Cinema Application SQL Queries

Cinema App Features

In one of my previous posts i explained the creation of Database Structure of our Cinema Application. You can proceed reading it here: Case Sample: Cinema Application ER Diagrams In this post, i started from scratch by firstly putting the requirement for Cinema Application and then designing the ER Diagrams.

With the ER Diagrams we catch many logical connections and constraints of our Application. Then, i proceeded with the conversion of ER Diagrams into Relational Schema and the actual SQL Implementation. For further read proceed here: Case Sample: Cinema Application, ER to Relational Model mapping and SQL implementation Now, i am going to implement couple of SQL queries and deduce some interesting statistics from our actual Database.

By: Leo On 23:54

Continue Reading

Case Sample: Cinema Application, ER to Relational Model mapping and SQL implementation

Cinema App ER Diagrams

We have already covered a topic regarding the design of ER diagrams for a Cinema. We have tried to capture as many relationships as possible. Please, refer to this topic so you can have an idea about our first post regarding the Cinema Application.

http://smartnoob.blogspot.com/2013/03/case-sample-cinema-application-er.html

By: Leo On 07:34

Continue Reading

Linking C# Applications with MySQL Databases on Visual Studio

Visual Studio as we know is a very powerful IDE from Microsoft. It has build in languages like C# C++ and Visual Basic. Development with Visual Studio can be pretty fun and successful. Visual Studio also has methods for creating and connecting to Databases like ADO.NET technology.

However for some personal reason you dont want to use ADO.NET technology for your Databases or SQLServer for the simple reason that they are expensive. Perhaps you want your applications data to live forever, and never be gone if your hard drive burns or dies.

By: Alias On 16:14

Continue Reading

Case Sample: Cinema Application ER Diagrams

Cinema ER Diagrams

Product or Service design is one of the most important steps on engineering. It's the step where you graphically create the specifications, features, goals and the main notes of the product/service requirements. In Software Development we have Software Design which is the activity after the setting of requirements and before programming implementation.

As we already know, the human brain captures better the pictures than words. Defining system features, concepts and complexes through some sort of standardized diagramming tools is far more better than describing it with words.In this case sample we will try to build ER Diagrams for Cinema Application. As previously explained  the design step is primary during the Software Development Process, in turn the step of Database Design is one of primary importance for the logical construction of Databases.

By: Leo On 07:36

Continue Reading